Tabela Accounts

Definicja tabeli Accounts

Name

Accounts

Code

Accounts

Comment

 


Lista kolumn tabeli Accounts

Name

Code

AccountID

AccountID

ResourceTypeID

ResourceTypeID

AccountGroupID

AccountGroupID

Code

Code

ShortName

ShortName

FullName

FullName

Constant

Constant

CostTypeID

CostTypeID

Imported

Imported

Income

Income

ExcludeFromManDayCost

ExcludeFromManDayCost

Active

Active

StartDT

StartDT

StopDT

StopDT


Kolumna AccountID tabeli Accounts

Definicja kolumny AccountID tabeli Accounts

Name

AccountID

Code

AccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceTypeID tabeli Accounts

Definicja kolumny ResourceTypeID tabeli Accounts

Name

ResourceTypeID

Code

ResourceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountGroupID tabeli Accounts

Definicja kolumny AccountGroupID tabeli Accounts

Name

AccountGroupID

Code

AccountGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli Accounts

Definicja kolumny Code tabeli Accounts

Name

Code

Code

Code

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli Accounts

Definicja kolumny ShortName tabeli Accounts

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli Accounts

Definicja kolumny FullName tabeli Accounts

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Constant tabeli Accounts

Definicja kolumny Constant tabeli Accounts

Name

Constant

Code

Constant

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostTypeID tabeli Accounts

Definicja kolumny CostTypeID tabeli Accounts

Name

CostTypeID

Code

CostTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Imported tabeli Accounts

Definicja kolumny Imported tabeli Accounts

Name

Imported

Code

Imported

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Income tabeli Accounts

Definicja kolumny Income tabeli Accounts

Name

Income

Code

Income

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ExcludeFromManDayCost tabeli Accounts

Definicja kolumny ExcludeFromManDayCost tabeli Accounts

Name

ExcludeFromManDayCost

Code

ExcludeFromManDayCost

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Active tabeli Accounts

Definicja kolumny Active tabeli Accounts

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Accounts

Definicja kolumny StartDT tabeli Accounts

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Accounts

Definicja kolumny StopDT tabeli Accounts

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli Accounts

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Accounts

Definicja klucza Identifier_1 tabeli Accounts

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment